﻿<html DIR="LTR" xmlns:tool="http://www.microsoft.com/tooltip" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:ddue="http://ddue.schemas.microsoft.com/authoring/2003/5" xmlns:MSHelp="http://msdn.microsoft.com/mshelp">
  <head>
    <META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=utf-8" />
    <META NAME="save" CONTENT="history" />
    <title>Readme_Exporting from ODBC to a Flat File Using a Wizard Tutorial: Lesson Packages</title>
    
    
    
    <style TYPE="text/css">
body
{
background: #FFFFFF;
color: #000000;
font-family:    Verdana;
font-size: medium;
font-style: normal;
font-weight: normal;
margin-top: 0;
margin-bottom:  0;
margin-left:    0;
margin-right:   0;
width:  100%;
}

div.#mainSection
{
font-size: 70%;
width: 100%;
padding-left:    10;
margin-right: 10;
}

div.#mainBody
{
font-size: 90%;
margin-top: 10;
padding-bottom: 20;
}

div.#header
{
background-color: #D2D2D2;
padding-top:    0;
padding-bottom: 0;
padding-left:   10;
padding-right:  0;
width:          100%;
}

div.#header table
{
border-bottom-color: #C8CDDE;
border-bottom-style: solid;
border-bottom-width: 1;
width:  100%;
}

span.#runningHeaderText
{
color: #003399;
font-size: 90%;
}

span.#nsrTitle
{
/*    color: #003399;*/
font-size: 120%;
font-weight: 600;
}

div.#header table td
{
color: #000000;
font-size: 70%;
margin-top: 0;
margin-bottom:  0;
padding-right: 20;
}

div.#header table tr.#headerTableRow3 td
{
padding-bottom: 2;
padding-top: 5;
}

div.#header table.#bottomTable
{
border-top-color: #FFFFFF;
border-top-style: solid;
border-top-width: 1;
text-align: left;
}

div.#footer
{
font-size: 90%;
margin-top: 0;
margin-bottom:  0;
margin-left:    -5;
margin-right:   0;
padding-top:    2;
padding-bottom: 2;
padding-left:   0;
padding-right:  0;
width:  100%;
}

hr.#footerHR
{
border-bottom-color: #EEEEFF;
border-bottom-style: solid;
border-bottom-width: 1;
border-top-color: C8CDDE;
border-top-style: solid;
border-top-width: 1;
height: 3;
color: #D2D2D2;
}

div.section
{
padding-top:    2;
padding-bottom: 2;
padding-right:  15;
width:  100%;
}

.heading
{
color:          #000000;
font-weight:    bold;
margin-top:     18;
margin-bottom:  8;
}

h1.heading
{
color: #000000;
font-size:  150%;
}

.subHeading
{
color:          #000000;
font-weight:    bold;
font-size:      150%;
margin-bottom:  4;
}

h2.subHeading
{
color:          #000000;
font-weight:    bold;
font-size:      130%;
}
h3.subHeading
{
color:  #000000;
font-size: 125%;
font-weight: bold;
}

h4.subHeading
{
color: #000000;
font-size: 110%;
font-weight: bold;
}

h4.procedureHeading
{
color: #000080;
font-size: 110%;
font-weight: bold;
}

h5.subHeading
{
color: #000000;
font-size: 100%;
font-weight: bold;
}

img
{
padding-bottom: 10;
}

img.toggle
{
border: 0;
margin-right: 5;
padding-bottom: 10;
}

img.copyCodeImage
{
border: 0;
margin: 1;
margin-right: 3;
padding-bottom: 10;
}

img.downloadCodeImage
{
border: 0;
margin-right: 3;
padding-bottom: 10;
}

img.viewCodeImage
{
border: 0;
margin-right: 3;
padding-bottom: 10;
}

img.note
{
border: 0;
margin-right: 3;
padding-bottom: 10;
}

img.#membersOptionsFilterImage
{
border: 0;
margin-left: 10;
vertical-align: middle;
padding-bottom: 10;
}

img.#toggleAllImage
{
margin-left: 4;
vertical-align: middle;
padding-bottom: 10;
}

div.#mainSection table
{
border: 0;
font-size: 100%;
width:  100%;
margin-top: 5px;
margin-bottom: 15px;
}

div.#mainSection table tr
{
vertical-align: top;
}

div.#mainSection table th
{
text-align: left;
background: #D8D8D8;
border-bottom-color: #D8D8D8;
border-bottom-style: solid;
border-bottom-width: 1;
color: #000000;
padding-left: 5;
padding-right: 5;
}

div.#mainSection table td
{
background: #F2F2F2;
border-top-color: #D8D8D8;
border-top-style: solid;
border-top-width: 1;
padding-left: 5;
padding-right: 5;
}

div.#mainSection table td.imageCell
{
white-space: nowrap;
}

div.code
{
width: 98%;
}

div.code table
{
border: 0;
font-size: 95%;
margin-bottom: 5;
width: 100%
}

div.code table th
{
text-align: left;
background: #D8D8D8;
border-bottom-color: #D8D8D8;
border-bottom-style: solid;
border-bottom-width: 1;
color: #000000;
font-weight: bold;
padding-left: 5;
padding-right: 5;
}

div.code table td
{
background: #CCCCCC;
border-top-color: #D8D8D8;
border-top-style: solid;
border-top-width: 1;
padding-left: 5;
padding-right: 5;
padding-top: 5;
}

div.alert
{
margin-left: 10;
width: 98%;
}

div.alert table
{
border: 1;
font-size: 100%;
width:  100%;
border: solid 1 #DEDFEF;
}

div.alert table th
{
text-align: left;
background: #D8D8D8;
border-bottom-width: 0;
color: #000000;
padding-left: 5;
padding-right: 5;
border: solid 1 #DEDFEF;
}

div.alert table td
{
background: #FFFFFF;
border-top-color: #D8D8D8;
border-top-style: solid;
border-top-width: 1;
padding-left: 5;
padding-right: 5;
border: solid 1 #DEDFEF;
}

span.copyCode
{
color: #0000ff;
font-size: 90%;
font-weight: normal;
cursor: hand;
float: right;
display: inline;
text-align: right;
}

.downloadCode
{
color: #0000ff;
font-size: 90%;
font-weight: normal;
cursor: hand;
}

.viewCode
{
color: #0000ff;
font-size: 90%;
font-weight: normal;
cursor: hand;
}

div.code pre
{
font-family:    Monospace, Courier New, Courier;
font-size: 105%;
color:  #000000;
}

code
{
font-family:    Monospace, Courier New, Courier;
font-size: 105%;
color:  #000000;
}

dl
{
margin-top: 0;
padding-left:   1;
}

dd
{
margin-bottom:  0;
margin-left:    0;
padding-left:   20;
}

dd p
{
margin-top: 5;
}

ul
{
margin-left: 17;
list-style-type: disc;
}

ul ul
{
margin-bottom: 4;
margin-left: 17;
margin-top: 3;
list-style-type: disc;
}

ol
{
margin-left: 24;
list-style-type: decimal;
}

ol ol
{
margin-left: 24;
margin-top: 3;
list-style-type: lower-alpha;
}

li
{
margin-top: 0;
margin-bottom: 0;
padding-bottom: 0;
padding-top: 0;
margin-left: 5;
}

p
{
margin-bottom: 15;
}

.tip
{
color:  #0000FF;
font-style: italic;
cursor:hand;
text-decoration:underline;
}

.math
{
font-family: Times New Roman;
font-size: 125%
}
.sourceCodeList
{
font-family: Verdana;
font-size: 90%;
}

pre.viewCode
{
width: 100%;
overflow: auto;
}

li:hover table, li.over table
{
background-color: #C0C0C0;
}

li:hover ul, li.over ul
{
background-color: #d2d2d2;
border: 1px solid #000;
display: block;
}
            </style>
  </head>
  <body>
    <!--Topic built:08/05/2008 01:28:33-->

    
    
    
    
    
    
    
    
    
    <div id="header">
      <table width="100%" id="topTable"><tr>
          <td align="left">
            <span id="nsrTitle">Readme_Exporting from ODBC to a Flat File Using a Wizard Tutorial: Lesson Packages</span>
          </td>
          <td align="right">
            <span id="headfb" class="feedbackhead">
            </span>
          </td>
        </tr></table>
      
      
      
    </div>
    <div id="mainSection">
      <div id="mainBody"><p> 08/05/2008 01:28:33</p>
        
        <font color="DarkGray"> </font><p /> 
        <span id="changeHistory">
        </span>
    <p>This sample works only with Microsoft SQL Server 2008. This sample will not work with any version of SQL Server earlier than SQL Server 2008.</p>
    <p>This sample works with the SQL Server 2005 version of the <b>AdventureWorks</b> OLTP database. To install this database, see <a href="http://go.microsoft.com/fwlink/?LinkId=122077" alt="blocked::http://go.microsoft.com/fwlink/?LinkId=122077"><linkText xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">Sample Databases for Microsoft SQL Server 2008</linkText></a>. </p>
    <p>The Export ODBC Lesson package is the completed package from the Integration Services tutorial, <b>Tutorial: Exporting from ODBC to a Flat File Using a Wizard</b>. The topics in Books Online provide detailed information about the functionality of this package. For more information, see the topics in "Exporting from ODBC to a Text File Using a Wizard" located in the Integration Services Tutorials section of Books Online. </p>
    <p>Briefly, the Export ODBC Lesson is a data transfer package that exports data from a SQL Server ODBC data source to an existing text file. The package extracts the data from a table in the <b>AdventureWorks</b> database and loads this data into the text file. This package was built by using the SQL Server Import and Export Wizard.</p>
    <p>You can open and run this package outside the tutorial. However, we do not recommend that you modify this package. Modification of this tutorial package might give you results that differ from the package results that were defined in the tutorial lessons.</p>
    <p>If you run the sample on a non-English version of Windows, you might have to substitute the localized name of the Program Files folder to open or run the sample.</p>
    <div class="alert"><table width="100%" cellspacing="0" cellpadding="0"><tr><th align="left">Important: </th></tr><tr><td>
      Samples are provided for educational purposes only. They are not intended to be used in a production environment and have not been tested in a production environment. Microsoft does not provide technical support for these samples.<p />
    </td></tr></table><p /></div>
  <h1 class="heading">Requirements</h1><div id="requirementsSection" class="section">
    <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <p xmlns="">To run this sample package, the following components are required:</p>
      <ul xmlns=""><li>
          The sample package and data files that the package uses must be installed on the local hard disk drive. <br />
        </li><li>
          You must have installed and have administrative permissions on the <b>AdventureWorks</b> OLTP database.<br />
        </li><li>
          If you run the sample package only from the command line, you must install Integration Services. <br />
        </li><li>
          If you open the package in SSIS Designer and run the sample package, you must install Business Intelligence Development Studio.<br />
        </li></ul>
      <p xmlns="">For more information about how to install samples, see "Considerations for Installing SQL Server Samples and Sample Databases" in SQL Server Books Online.</p>
    </content>
  </div><h1 class="heading">Location of the Sample Package</h1><div id="sectionSection0" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <p xmlns="">If you installed the samples to the default installation location, the tutorial sample package is located in the following folder: </p>
      <p xmlns="">
        C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Tutorial\Exporting ODBC to Flat File\Completed Packages</p>
      <p xmlns="">To run this sample package, the files listed in the following table must be stored on the computer that is running the package.</p>
      <table width="100%" cellspacing="0" cellpadding="0" border="1" style="background-color: #CCCCCC;" xmlns=""><tr>
            <th>
              File
            </th>
            <th>
              Description
            </th>
          </tr><tr>
          <td>
            <p>Export ODBC Lesson.dtxs</p>
          </td>
          <td>
            <p>The sample package.</p>
          </td>
        </tr><tr>
          <td>
            <p>FlatFile.txt</p>
          </td>
          <td>
            <p>The text file that contains the data that is exported from a SQL Server ODBC data source.</p>
          </td>
        </tr></table>
    </content></div><h1 class="heading">Running the Sample</h1><div id="sectionSection1" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <p xmlns="">The package can be run from the command line by using the <b>dtexec</b> utility (dtexec.exe), or can be run in Business Intelligence Development Studio..</p>
    </content><sections xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <h3 class="subHeading" xmlns="">Running the Sample at the Command Prompt</h3><div class="subSection" xmlns=""><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
          <p xmlns="">Use the following procedure to use the <b>dtexec</b> utility to run this sample package. For more information about how to use the <b>dtexec</b> utility to run a package, see the topic, "dtexec Utility," in SQL Server Books Online.</p>
          <h4 class="procedureHeading" xmlns="">To run the package by using dtexec</h4><div id="procedureSectionEBBDBDBHA" class="section" xmlns=""><ol><li>
                <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
                  <p xmlns="">Open a Command Prompt window.</p>
                </content>
              </li><li>
                <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
                  <p xmlns="">At the command prompt, change the directory to <i>&lt;drive&gt;</i>:\Program Files\Microsoft SQL Server\100\DTS\Binn.</p>
                  <p xmlns="">This directory contains the <b>dtexec</b> utility.</p>
                </content>
              </li><li>
                <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
                  <p xmlns="">Type the following command:</p>
                  <div class="code" xmlns=""><span codeLanguage="other"><table width="100%" cellspacing="0" cellpadding="0"><tr><th align="left" /></tr><tr><td colspan="2"><pre>dtexec /f "C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Tutorial\Exporting ODBC to Flat File\Completed Packages\Export ODBC Lesson.dtsx"</pre></td></tr></table></span></div>
                </content>
              </li><li>
                <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
                  <p xmlns="">Press ENTER.</p>
                </content>
              </li></ol></div>
        </content></div>
      <h3 class="subHeading" xmlns="">Running the Sample in Business Intelligence Development Studio</h3><div class="subSection" xmlns=""><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
          <p xmlns="">If you do not already have an Integration Services project to which you can add the tutorial packages, you must first create a project.</p>
          <h4 class="procedureHeading" xmlns="">To create a new Integration Services project</h4><div id="procedureSectionEFBBBDBHA" class="section" xmlns=""><ol><li>
                <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
                  <p xmlns="">Open Business Intelligence Development Studio.</p>
                </content>
              </li><li>
                <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
                  <p xmlns="">On the <b>File</b> menu, point to <b>New</b>, and then click <b>Project</b>. </p>
                </content>
              </li><li>
                <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
                  <p xmlns="">In the <b>New Project</b> dialog box, select the <b>Integration Services Project</b> template from the <b>Templates</b> pane. </p>
                </content>
              </li><li>
                <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
                  <p xmlns="">Optionally, modify the project name and the location.</p>
                  <p xmlns="">The solution name is automatically updated to match the project name.</p>
                </content>
              </li><li>
                <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
                  <p xmlns="">In the <b>Solution</b> drop-down list, select <b>Create new Solution</b>.</p>
                </content>
              </li><li>
                <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
                  <p xmlns="">To create a separate folder for the solution file, select <b>Create directory for solution</b>.</p>
                  <p xmlns="">This is the default option.</p>
                </content>
              </li><li>
                <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
                  <p xmlns="">Click <b>OK</b> to add the solution to <b>Solution Explore</b>r and add the project to the solution.</p>
                </content>
              </li></ol></div>
          <p xmlns="">Next, you add the packages to the Integration Services project.</p>
          <h4 class="procedureHeading" xmlns="">To run the package in Business Intelligence Development Studio</h4><div id="procedureSectionEBBBBDBHA" class="section" xmlns=""><ol><li>
                <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
                  <p xmlns="">In Solution Explorer, right-click <b>SSIS Packages</b>, and then click <b>Add Existing Package</b>.</p>
                </content>
              </li><li>
                <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
                  <p xmlns="">In the <b>Add Copy of Existing Package</b> dialog box, set <b>Package location</b> to <b>File system</b>, click browse <b>(…)</b>, and locate the folder that contains the completed package from the tutorial.</p>
                  <p xmlns="">The default location is C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Tutorial\Exporting ODBC to Flat File\Completed Packages.</p>
                </content>
              </li><li>
                <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
                  <p xmlns="">Click the package, and then click <b>Open</b>.</p>
                </content>
              </li><li>
                <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
                  <p xmlns="">Click <b>OK</b>.</p>
                </content>
              </li><li>
                <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
                  <p xmlns="">In the <b>SSIS Packages</b> folder, right-click the package to run, and then click <b>Execute Package</b>. </p>
                </content>
              </li></ol></div>
        </content></div>
    </sections></div><!--[if gte IE 5]>
			<tool:tip element="seeAlsoToolTip" avoidmouse="false"/><tool:tip element="languageFilterToolTip" avoidmouse="false"/><tool:tip element="roleInfoSpan" avoidmouse="false"/>
		<![endif]--></div>
      <div id="footer">
			
			© 2008 Microsoft Corporation. All rights reserved.
		</div>
    </div>
  </body>
</html>